﻿CREATE PROCEDURE [dbo].[ListarNegociosPorCategoria] 
	@negocio nvarchar(50)
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;
select Negocio.descripcion from Negocio
inner join CategoriaNegocio on CategoriaNegocio.id_negocio =Negocio.id_negocio
inner join Categoria on Categoria.id_categ = CategoriaNegocio.id_cat
where Categoria.descripcion like '%'+@negocio+'%'
END